To enable people who aren't SQL Server administrators to view the Analytics analysis database by using the Analytics Briefing Book, you must enable the Everyone role in SQL Server to have read access to the analysis database.
Before you begin
■ Analytics must be properly installed and configured. See Installing Analytics for more information.
To grant read access to the analysis database
1. Using Microsoft SQL Server Management Studio, connect to Analysis Services on the Analytics host.
2. In the Object Explorer pane, expand the tree to view the contents of the Databases > iAnalytics > Roles folder.
3. Right-click the everyone role and choose Properties.
The Edit Role window appears.
4. On the Data Sources page, in the iAnalytics data source row, specify Read access and select the Read Definition checkbox.
5. On the Cubes page, in the iMIS cube name row, specify Read access, Drillthrough local cube/drillthrough access, and select the Process checkbox.
6. Click OK to save your changes.